from openpyxl import load_workbook
planeTypeDict = {"332": "W", "333": "W", "33E": "W", "33H": "W", "33L": "W", "773": "W", "319": "N", "320": "N",
                 "321": "N", "323": "N", "325":"N","738":"N","73A":"N","73E":"N","73H":"N","73L":"N"}
wb = load_workbook("InputData.xlsx")
print(wb.sheetnames)
ws = wb.worksheets[0]
print(ws.title)
print(ws["F4"].value)
print(len(ws["A"]))
L=[]
for i in range(len(ws["F"])-1):
    L.append(str(ws["F%d" % (i+2)].value))
print(L)
print(len(L))
for i in range(len(ws["F"])-1):
#     # ws["M%d" % (i+2)].value=planeTypeDict[L[i]]
#     # print(planeTypeDict[L[i]])
    ws["M%d" % (i + 2)]=planeTypeDict[L[i]]

wb.save("InputData.xlsx")
